package pers.sports.dao;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import pers.sports.vo.ApplyDetailed;
import pers.sports.vo.VolunteerInfo;

import java.util.List;

@Repository
public interface ApplyDao {

    //查找待审核的申请
    List<ApplyDetailed> findApplyInfo(Integer page, Integer limit, Integer review);

    Integer updateReview(Integer id, Integer review);

    //查询自己的报名信息
    List<ApplyDetailed> findSelfApply(@Param("stuId") String stuId);

    //删除信息
    void deleteById(@Param("applyId") String applyId);

    //获取通过的运动员信息
    List<String> getReviewPass();

    //添加新的
    int insertVolunteer(@Param("stuId") String stuId);


    int findVolunteerByStuId(@Param("stuId") String stuId);

    void insertScoreByApplyId(@Param("id") Integer id);

    void deleteScoreByApplyId(@Param("id") Integer id);

    List<VolunteerInfo> findAllVolunteer();
}
